INSERT INTO C##MRU_OPTIMIZED.groups(ID, DESCRIPTION, NAME) values (1, 'Administrator', 'Administrator');
INSERT INTO C##MRU_OPTIMIZED.users(id, email, enabled, user_name, password, informed, group_id)
values (1, 'admin@admin.com', 1, 'admin', '$2a$10$NMpfOIOsbSkeJ5xrIivgQu.y9Zu3DnkeITqJsXXg2evm.orKXaH3i', 1, 1);

INSERT INTO FAMILY_STATUSES (ID, NAME) values (1,'Casatorit');
INSERT INTO FAMILY_STATUSES (ID, NAME) values (2,'Necasatorit');

INSERT INTO FUNCTION_CATEGORIES (ID,ABBREVIATION,NAME,SHORT_NAME) values (1,'M',      'MAPA',                                                                         'Mapa');
INSERT INTO FUNCTION_CATEGORIES (ID,ABBREVIATION,NAME,SHORT_NAME) values (2,'FPSS',   'Funcție publică cu statut special',                                            'FP statut special');
INSERT INTO FUNCTION_CATEGORIES (ID,ABBREVIATION,NAME,SHORT_NAME) values (3,'FPC',    'Funcție publică de conducere',                                                 'FP conducere');
INSERT INTO FUNCTION_CATEGORIES (ID,ABBREVIATION,NAME,SHORT_NAME) values (4,'FPE',    'Funcție publică de execuție',                                                  'FP execuție');
INSERT INTO FUNCTION_CATEGORIES (ID,ABBREVIATION,NAME,SHORT_NAME) values (5,'PDTAFAP','Personal auxiliar',                                                            'Auxiliar');
INSERT INTO FUNCTION_CATEGORIES (ID,ABBREVIATION,NAME,SHORT_NAME) values (6,'FDP',    'Funcție de demnitate publică',                                                 'F de demnitate publică');
INSERT INTO FUNCTION_CATEGORIES (ID,ABBREVIATION,NAME,SHORT_NAME) values (7,'PCPFDP', 'Post din cadrul cabinetului persoanei ce exercită funcție de demnitate public','Post in cabinetul FDP');
INSERT INTO FUNCTION_CATEGORIES (ID,ABBREVIATION,NAME,SHORT_NAME) values (8,'FPCNS',  'Funcție publică de conducere de nivelul superior',                             'FP conducere superior');

INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (1, 'FOLDER_OFFICE',      'Birou',null,1);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (2, 'FOLDER_DEPARTMENT',  'Directie',null,1);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (3, 'FOLDER_SECTION',     'Sectie',null,1);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (4, 'FOLDER_POST',        'Post',null,1);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (5, 'POSITION','Director general',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (6, 'POSITION','Sef directie',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (7, 'POSITION','Sef adjunct directie',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (8, 'POSITION','Sef sectie',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (9, 'POSITION','Auditor',null,4);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (10, 'POSITION','Inspector principal',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (11,'POSITION','Inspector superior',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (12,'POSITION','Șef departament',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (13,'POSITION','Sef adjunct departament',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (14,'POSITION','Sef sector',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (15,'POSITION','Conducator auto',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (16,'POSITION','Telefonist',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (17,'POSITION','Camerista',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (18,'POSITION','Ingrijitor cladiri administrative',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (19,'POSITION','Muncitor auxiliar',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (20,'POSITION','Electrician',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (21,'POSITION','Maturator',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (22,'POSITION','Timplar',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (23,'POSITION','Lacatus',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (24,'POSITION','Gradinar',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (25,'POSITION','Tractorist',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (26,'POSITION','Paznic',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (27,'POSITION','Operator protectie automata antigaz',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (28,'POSITION','Șef direcție','1.0',3);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (29,'POSITION','Șef adjunct direcție',null,3);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (30,'POSITION','Șef birou vamal',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (31,'POSITION','Șef adjunct birou vamal',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (32,'POSITION','Șef secție',null,3);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (33,'POSITION','Șef secție',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (34,'POSITION','Șef serviciu',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (35,'POSITION','Șef serviciu',null,3);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (36,'POSITION','Șef serviciu',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (37,'POSITION','Șef post vamal',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (38,'POSITION','Șef adjunct post vamal',null,2);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (39,'POSITION','Specialist principal',null,4);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (40,'POSITION','Specialist principal',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (41,'POSITION','Specialist superior',null,4);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (42,'POSITION','Specialist superior',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (43,'POSITION','Specialist',null,4);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (44,'POSITION','Specialist',null,5);
INSERT INTO C##MRU_OPTIMIZED.FUNCTIONS (ID,FUNCTION_TYPE,NAME,POSITION,FUNCTION_CATEGORY_ID) values (45,'POSITION','Inspector',null,2);


INSERT INTO NATIONALITIES (ID, NAME) values (1,'MD');
INSERT INTO NATIONALITIES (ID, NAME) values (2,'RO');
INSERT INTO NATIONALITIES (ID, NAME) values (3,'UK');
INSERT INTO NATIONALITIES (ID, NAME) values (4,'EU');

/* IMPORT DATA FOR salary_levels TABLE */
INSERT INTO salary_levels VALUES ( 1, '1');
INSERT INTO salary_levels VALUES ( 2, '2');
INSERT INTO salary_levels VALUES ( 3, '3');
INSERT INTO salary_levels VALUES ( 4, '4');
INSERT INTO salary_levels VALUES ( 5, '5');
INSERT INTO salary_levels VALUES ( 6, '6');
INSERT INTO salary_levels VALUES ( 7, '7');
INSERT INTO salary_levels VALUES ( 8, '8');
INSERT INTO salary_levels VALUES ( 9, '9');
INSERT INTO salary_levels VALUES (10, '10');
INSERT INTO salary_levels VALUES (11, '11');
INSERT INTO salary_levels VALUES (12, '12');
INSERT INTO salary_levels VALUES (13, '13');
INSERT INTO salary_levels VALUES (14, '14');
INSERT INTO salary_levels VALUES (15, '15');
INSERT INTO salary_levels VALUES (16, '16');
INSERT INTO salary_levels VALUES (17, '17');
INSERT INTO salary_levels VALUES (18, '18');
INSERT INTO salary_levels VALUES (19, '19');
INSERT INTO salary_levels VALUES (20, '20');
INSERT INTO salary_levels VALUES (21, '21');
INSERT INTO salary_levels VALUES (22, '22');
INSERT INTO salary_levels VALUES (23, '23');

/* IMPORT DATA FOR salary_steps TABLE */
INSERT INTO salary_steps VALUES ( 1, 'I');
INSERT INTO salary_steps VALUES ( 2, 'II');
INSERT INTO salary_steps VALUES ( 3, 'III');
INSERT INTO salary_steps VALUES ( 4, 'IV');
INSERT INTO salary_steps VALUES ( 5, 'V');
INSERT INTO salary_steps VALUES ( 6, 'VI');
INSERT INTO salary_steps VALUES ( 7, 'VII');
INSERT INTO salary_steps VALUES ( 8, 'VIII');
INSERT INTO salary_steps VALUES ( 9, 'IX');

INSERT INTO order_type_groups (ID, NAME, ICON) values (1, 'Angajare',               'custom-ico-anagajare');
INSERT INTO order_type_groups (ID, NAME, ICON) values (2, 'Eliberare',              'custom-ico-eliberare');
INSERT INTO order_type_groups (ID, NAME, ICON) values (3, 'Suspendare',             'custom-ico-suspendare');
INSERT INTO order_type_groups (ID, NAME, ICON) values (4, 'Transferare',            'custom-ico-transferare');
INSERT INTO order_type_groups (ID, NAME, ICON) values (5, 'Concediu',               'custom-ico-concedii');
INSERT INTO order_type_groups (ID, NAME, ICON) values (6, 'Deplasare/Detasare',              'custom-ico-detasare');
INSERT INTO order_type_groups (ID, NAME, ICON) values (7, 'Avansare',               'custom-ico-avansare');
INSERT INTO order_type_groups (ID, NAME, ICON) values (8, 'Stimulare',              'custom-ico-stimulare');
INSERT INTO order_type_groups (ID, NAME, ICON) values (9, 'Cursuri',                'custom-ico-cursuri');
INSERT INTO order_type_groups (ID, NAME, ICON) values (10,'Sanctiuni',              'custom-ico-sanctiuni');
INSERT INTO order_type_groups (ID, NAME, ICON) values (11,'Atestare',               'custom-ico-atestare');
INSERT INTO order_type_groups (ID, NAME, ICON) values (12,'Repunere',               'custom-ico-repunere');
INSERT INTO order_type_groups (ID, NAME, ICON) values (13,'Incapacitate de Munca',  'custom-ico-eliberare-incapacitate-munca');
INSERT INTO order_type_groups (ID, NAME, ICON) values (14,'Rechemare',              'custom-ico-repunere');
INSERT INTO order_type_groups (ID, NAME, ICON) values (15,'Adaos la concediu',      'custom-ico-stimulare');


INSERT INTO folder_states (ID, NAME, block_position, icon) values (1,'Nou', 0, null);
INSERT INTO folder_states (ID, NAME, block_position, icon) values (2,'Angajat', 1, 'custom-ico-anagajare');
INSERT INTO folder_states (ID, NAME, block_position, icon) values (3,'Concediat', 0, 'custom-ico-eliberare');
INSERT INTO folder_states (ID, NAME, block_position, icon) values (4,'Suspendat', 0, 'custom-ico-suspendare');
INSERT INTO folder_states (ID, NAME, block_position, icon) values (5,'Con.maternitate', 0, 'custom-ico-concedii');
INSERT INTO folder_states (ID, NAME, block_position, icon) values (6,'Concediu', 0, 'custom-ico-concedii');
INSERT INTO folder_states (ID, NAME, block_position, icon) values (7,'Validat', 0, null);
INSERT INTO folder_states (ID, NAME, block_position, icon) values (8,'Deplasare', 1, 'custom-ico-deplasare');
INSERT INTO folder_states (ID, NAME, block_position, icon) values (9,'Cursuri', 1, 'custom-ico-cursuri');
INSERT INTO folder_states (ID, NAME, block_position, icon) values (10,'Incapacitate de munca', 1, 'custom-ico-eliberare-incapacitate-munca');

INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (2, 2);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (2, 3);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (2, 4);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (2, 5);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (2, 6);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (2, 7);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (2, 8);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (2, 9);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (2, 10);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (2, 11);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (2, 13);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (2, 15);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (4, 2);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (4, 12);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (4, 14);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (5, 14);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (5, 15);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (6, 14);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (6, 15);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (8, 14);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (9, 14);
INSERT INTO folder_states_order_groups (FOLDER_STATE_ID, ORDER_TYPE_GROUP_ID) values (10, 14);



/* Angajare */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (1,'Concurs', 'custom-ico-anagajare-concurs', null, null, null, null, 1, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (2,'Cerere', 'custom-ico-anagajare-concurs', null, null, null, null, 1, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (3,'Efectuare practica', 'custom-ico-anagajare-concurs', null, null, null, null, 1, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (4,'Transfer de la alta institutie', 'custom-ico-anagajare-concurs', null, null, null, null, 1, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (5,'Exercitarea atribuţiilor de serviciu', 'custom-ico-anagajare-concurs', null, null, null, null, 1, 2);

/* Eliberare */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (6,'Din propria initiativa', 'custom-ico-eliberare', null, null, null, null, 2, 3);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (7,'Excluderea din lista personalului', 'custom-ico-eliberare', null, null, null, null, 2, 3);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (8,'Conform hotaririi judecatoresti', 'custom-ico-eliberare', null, null, null, null, 2, 3);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (9,'Modificare statut de personal', 'custom-ico-eliberare', null, null, null, null, 2, 3);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (10,'Expirarea contractului', 'custom-ico-eliberare', null, null, null, null, 2, 3);

/* Suspendare */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (11,'Suspendare din initiativa proprie', 'custom-ico-suspendare', 2, null, null, null, 3, 4);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (12,'Conform hotaririi judecatoresti', 'custom-ico-suspendare', 2, null, null, null, 3, 4);

/* Transfer */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (13,'Transfer intern', 'custom-ico-transferare', null, null, null, null, 4, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (14,'Permutare', 'custom-ico-transferare', null, null, null, null, 4, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (15,'Promovare', 'custom-ico-transferare', null, null, null, null, 4, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (16,'Funcţie de demnitate publică', 'custom-ico-transferare', null, null, null, null, 4, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (17,'Personal auxiliar', 'custom-ico-transferare', null, null, null, null, 4, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (18,'Funcţionar public', 'custom-ico-transferare', null, null, null, null, 4, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (19,'Funcţionar public cu statut special', 'custom-ico-transferare', null, null, null, null, 4, 2);


/* Concediu */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (20,'Concediu ordinar', 'custom-ico-concedii', 2, 'Persoana @NAME se reintoarce din concediu ordinar in @DAYS', 5, null, 5, 6);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (21,'Concediu din cont propriu', 'custom-ico-concedii', 2, 'Persoana @NAME se reintoarce din concediu cont propriu in @DAYS', 5, null, 5, 6);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (22,'Concediu studii', 'custom-ico-concedii', 2, 'Persoana @NAME se reintoarce din concediu de studii in @DAYS', 10, null, 5, 6);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (23,'Concediu medical', 'custom-ico-concedii', 2, null , null, null, 5, 6);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (24,'Concediu ingrijirea copilului platit', 'custom-ico-concedii', 2, 'Persoana @NAME se reintoarce din concediu pentru ingrigirea copilului in @DAYS', 10, null, 5, 5);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (25,'Concediu ingrijirea copilului neplatit', 'custom-ico-concedii', 2, 'Persoana @NAME se reintoarce din concediu pentru ingrigirea copilului in @DAYS', 10, null, 5, 5);

/* Deplasare/Detasare */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (26,'Deplasare', 'custom-ico-deplasare', 2, 'Persoana @NAME se reintoarce din deplasare ordinar in @DAYS', 5, null, 6, 8);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (27,'Detasare', 'custom-ico-deplasare', 2, 'Persoana @NAME se reintoarce din detasare ordinar in @DAYS', 10, null, 6, 8);

/* Avansare */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (28,'Atestat grad iniţial', 'custom-ico-avansare', null, null , null , null, 7, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (29,'Atestat grad ulterior', 'custom-ico-avansare', null, null , null , null, 7, 2);

/* Stimulare */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (30,'Mulţumire', 'custom-ico-stimulare', null, null , null , null, 8, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (31,'Premiu bănesc', 'custom-ico-stimulare', null, null , null , null, 8, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (32,'Cadou de preţ', 'custom-ico-stimulare', null, null , null , null, 8, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (33,'Diplomă de Onoare', 'custom-ico-stimulare', null, null , null , null, 8, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (34,'Eminent al serviciului vamal', 'custom-ico-stimulare', null, null , null , null, 8, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (35,'Colaborator vamal de onoare al RM', 'custom-ico-stimulare', null, null , null , null, 8, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (36,'Gradul special ulterior', 'custom-ico-stimulare', null, null , null , null, 8, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (37,'Gradul special ulterior peste o treaptă', 'custom-ico-stimulare', null, null , null , null, 8, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (38,'Anularea sancţiunii disciplinare', 'custom-ico-stimulare', null, null , null , null, 8, 2);

/* Cursuri */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (39,'Cursuri', 'custom-ico-cursuri', 2, 'Persoana @NAME se reintoarce de la cursuri in @DAYS', 5 , null, 9, 9);

/* Sanctiuni */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (40,'Observaţie', 'custom-ico-sanctiuni', null, null , null , null, 10, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (41,'Mustrare', 'custom-ico-sanctiuni', null, null , null , null, 10, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (42,'Mustrare aspră', 'custom-ico-sanctiuni', null, null , null , null, 10, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (43,'Retrogradarea în funcţie pe 6 luni', 'custom-ico-sanctiuni', null, null , null , null, 10, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (44,'Reţinerea conferirii gradului special', 'custom-ico-sanctiuni', null, null , null , null, 10, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (45,'Reţinerea conferirii gradului special', 'custom-ico-sanctiuni', null, null , null , null, 10, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (46,'Preîntâmpinare de ne corespundere', 'custom-ico-sanctiuni', null, null , null , null, 10, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (47,'eliberarea din serviciu', 'custom-ico-sanctiuni', null, null , null , null, 10, 2);

/* Atestare */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (48,'Director general', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (49,'Sef directie', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (50,'Sef adjunct directie', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (51,'Sef sectie', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (52,'Consultant', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (53,'Inspector principal', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (54,'Sef serviciu', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (55,'Inspector superior', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (56,'Sef adjunct sectie', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (57,'Director departament', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (59,'Vicedirector departament', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (60,'Sef sector', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (61,'Conducator auto', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (62,'Telefonist', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (63,'Camerista', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (64,'Ingrijitor cladiri administrative', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (65,'Muncitor auxiliar', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (66,'Electrician', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (67,'Maturator', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (68,'Timplar', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (69,'Lacatus', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (70,'Gradinar', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (71,'Tractorist', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (72,'Paznic', 'custom-ico-atestare', null, null , null , null, 11, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (73,'Operator protectie automata antigaz', 'custom-ico-atestare', null, null , null , null, 11, 2);

/* Repunere */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (74,'Repunere', 'custom-ico-repunere', null, null , null , null, 12, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (75,'Repunere in timpul conediului de maternitate platit', 'custom-ico-repunere', null, null , null , null, 12, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (76,'Repunere dupa concediu maternitate neplatit', 'custom-ico-repunere', null, null , null , null, 12, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (77,'Repunere in timpul conediului de maternitate neplatit', 'custom-ico-repunere', null, null , null , null, 12, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (78,'Repunere dupa suspendare', 'custom-ico-repunere', null, null , null , null, 12, 2);
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (79,'Repunere dupa concediere', 'custom-ico-repunere', null, null , null , null, 12, 2);

/* Incapacitate de Munca */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (80,'Incapacitate de munca', 'custom-ico-eliberare-incapacitate-munca', 2, 'Persoana @NAME se reintoarce din concediu de incapacitate de munca in @DAYS', 2, null, 13, 10);

/* Rechemare */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (81,'Rechemare', 'custom-ico-repunere', null, null , null , null, 14, 2);

/* Adaos la concediu */
INSERT INTO order_types (ID, NAME, ICON, CHANGE_TO_FOLDER_STATE_ID, NOTIFICATION, SHOW_BEFORE_DAYS, REPEAT_NOTIFICATION, ORDER_TYPE_GROUP_ID, FOLDER_STATE_ID)
values (82,'Adaos la concediu', 'custom-ico-stimulare', null, null , null , null, 15, 2);


INSERT INTO C##MRU_OPTIMIZED.ISSUERS (ID,NAME,VISIBLE) values (1,'Buletin medical',0);
INSERT INTO C##MRU_OPTIMIZED.ISSUERS (ID,NAME,VISIBLE) values (2,'Ordin SV',1);
INSERT INTO C##MRU_OPTIMIZED.ISSUERS (ID,NAME,VISIBLE) values (3,'Ordin BV',1);

INSERT INTO C##MRU_OPTIMIZED.ADVANCEMENT_RANKS (ID,NAME) values (1,'Plutonier');
INSERT INTO C##MRU_OPTIMIZED.ADVANCEMENT_RANKS (ID,NAME) values (2,'Plutonier major');
INSERT INTO C##MRU_OPTIMIZED.ADVANCEMENT_RANKS (ID,NAME) values (3,'Sublocotinent');
INSERT INTO C##MRU_OPTIMIZED.ADVANCEMENT_RANKS (ID,NAME) values (4,'Locotinent');
INSERT INTO C##MRU_OPTIMIZED.ADVANCEMENT_RANKS (ID,NAME) values (5,'Capitan');
INSERT INTO C##MRU_OPTIMIZED.ADVANCEMENT_RANKS (ID,NAME) values (6,'Maior');
INSERT INTO C##MRU_OPTIMIZED.ADVANCEMENT_RANKS (ID,NAME) values (7,'Locotenent-colonel');
INSERT INTO C##MRU_OPTIMIZED.ADVANCEMENT_RANKS (ID,NAME) values (8,'Colonel');
INSERT INTO C##MRU_OPTIMIZED.ADVANCEMENT_RANKS (ID,NAME) values (9,'General-maior');
INSERT INTO C##MRU_OPTIMIZED.ADVANCEMENT_RANKS (ID,NAME) values (10,'General-locotinent');
INSERT INTO C##MRU_OPTIMIZED.ADVANCEMENT_RANKS (ID,NAME) values (11,'General-colonel');

INSERT INTO C##MRU_OPTIMIZED.EFFECTIVES (ID,NAME) values (1,'Efectiv inferior');
INSERT INTO C##MRU_OPTIMIZED.EFFECTIVES (ID,NAME) values (2,'Efectiv de comanda mediu');
INSERT INTO C##MRU_OPTIMIZED.EFFECTIVES (ID,NAME) values (3,'Efectiv de comanda superior');
INSERT INTO C##MRU_OPTIMIZED.EFFECTIVES (ID,NAME) values (4,'Efectiv de comanda suprem');

INSERT INTO C##MRU_OPTIMIZED.PUBLIC_FUNCTIONS (ID,NAME) values (1,'Functie publica de conducere de nivel superior');
INSERT INTO C##MRU_OPTIMIZED.PUBLIC_FUNCTIONS (ID,NAME) values (2,'Personal auxiliar');
INSERT INTO C##MRU_OPTIMIZED.PUBLIC_FUNCTIONS (ID,NAME) values (3,'Functie publica de executie');
INSERT INTO C##MRU_OPTIMIZED.PUBLIC_FUNCTIONS (ID,NAME) values (4,'Functie publica de conducere');

INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@NUME_SEF', null, 'Tudor BALIŢCHI', 'CHANGE_VALUE_SYSTEM_TAG');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@NUME_INSTITUTIE', null, 'MINISTERUL FINANŢELOR AL REPUBLICII MOLDOVA </br> SERVICIUL VAMAL', 'CHANGE_VALUE_SYSTEM_TAG');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@AN_CURENT', null, null, 'CURRENT_YEAR');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@LOCATIE_BIROU', null, null , 'OFFICE_LOCATION');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@ADRESARE_1', null, null , 'ADDRESSING_1');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@ADRESARE_2', null, null , 'ADDRESSING_2');

INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@BIROU', null, null, 'OFFICE_NAME');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@DIRECTIA', null, null, 'DEPARTMENT_NAME');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@SECTIA', null, null, 'SECTION_NAME');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@FUNCTIA', null, null, 'FUNCTION_NAME');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@PERIOADA_DE_PROBA', null, null , 'TRIAL_PERIOD');

INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@NUME', null, null, 'NAME');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@TEMEI', null, null, 'GROUND');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@DATA_START', null, null, 'START_DATE');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@DATA_SFARSIT', null, null, 'END_DATE');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@INSTITUTIE_INVATAMANT', null, null, 'EDUCATION_INSTITUTION');
INSERT INTO C##MRU_OPTIMIZED.SYSTEM_TAGS (ID,NAME,DESCRIPTION,VALUE,SYSTEM_TAG_TYPE) values (SYSTEM_TAGS_SEQUENCE.NEXTVAL, '@TRANSFER_DE_LA', null, null, 'TRANSFER_FROM');


